package com.iflytek.universitymanagement.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.iflytek.universitymanagement.domain.StudentCompetition;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;
import java.util.Map;

public interface StudentCompetitionService extends IService<StudentCompetition> {

//    // 声明方法：查询学生的所有竞赛参与情况，带上竞赛名称
//    List<Map<String, Object>> getStudentCompetitionsWithDetails(Integer studentId);


    // 根据学生姓名查询学生的竞赛数据
    List<Map<String, Object>> getStudentCompetitionsByStudentName(String studentName);

    // 根据学生ID查询竞赛数据并封装竞赛名称
    List<Map<String, Object>> getStudentCompetitionsWithDetails(Integer studentId);

    IPage<StudentCompetition> selectPage(int pageNum, int pageSize, String name, String competitionName);


    boolean add(StudentCompetition studentCompetition);

    Map<String, Object> getStudentCompetitionData(String studentName);
}

